package cj.hrm.dao;



import cj.hrm.entity.Sex;
import org.apache.ibatis.annotations.Select;

import java.util.List;

import static cj.hrm.util.common.HrmConstants.SEXTABLE;


public interface SexDao {
	//查询
		@Select("select * from "+SEXTABLE+" ")
		List<Sex> selectAllSex();
		
		@Select("select * from "+SEXTABLE+" where name like CONCAT('%',#{content},'%')")
		List<Sex> selectLikeAllSex(String content);
		
		@Select("select * from "+SEXTABLE+" where id = #{id}")
		Sex selectById(Integer id);
}
